﻿CREATE TABLE [v1bgt].[CostCentreJournalSet] (
    [CostCentreJournalSetId] INT           IDENTITY (1, 1) NOT NULL,
    [CompanyJournalSetId]    INT           NOT NULL,
    [CostCentreId]           INT           NOT NULL,
    [JournalSetStatusId]     SMALLINT      NOT NULL,
    [JournalSetName]         VARCHAR (50)  NULL,
    [JournalSetDescription]  VARCHAR (200) NULL,
    [ReferenceMonth]         DATETIME      NOT NULL,
    [CurrentFlag]            CHAR (1)      NULL,
    [CreatedBy]              VARCHAR (50)  NULL,
    [UpdatedBy]              VARCHAR (50)  NULL,
    [CreateDate]             DATETIME      NOT NULL,
    [UpdateDate]             DATETIME      NOT NULL,
    PRIMARY KEY CLUSTERED ([CostCentreJournalSetId] ASC) WITH (FILLFACTOR = 90, ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

